Overview
Brought to you by YData
Dataset statistics
| Number of variables | 33 |
|---|---|
| Number of observations | 141250 |
| Missing cells | 705426 |
| Missing cells (%) | 15.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 203.3 MiB |
| Average record size in memory | 1.5 KiB |
Variable types
| Text | 6 |
|---|---|
| Categorical | 14 |
| Numeric | 6 |
| Unsupported | 1 |
| Boolean | 1 |
| DateTime | 5 |
Card Expiration Date has constant value "12/28" | Constant |
Bank Name has constant value "Bank of Example" | Constant |
Bank Account Type has constant value "Checking" | Constant |
AVS Result Code has constant value "True" | Constant |
CVV/CVC Result Code has constant value "M" | Constant |
Fraud Action has constant value "allow" | Constant |
Card Brand is highly overall correlated with Merchant Processor Type and 2 other fields | High correlation |
Card Last 4 Digits is highly overall correlated with Payment Gateway Type and 1 other fields | High correlation |
Gateway Net Settled Amount is highly overall correlated with Net Amount to Merchant and 3 other fields | High correlation |
Merchant Account ID is highly overall correlated with Merchant Processor Type and 3 other fields | High correlation |
Merchant Processor Type is highly overall correlated with Card Brand and 4 other fields | High correlation |
Net Amount to Merchant is highly overall correlated with Gateway Net Settled Amount and 3 other fields | High correlation |
Payment Gateway Type is highly overall correlated with Card Brand and 5 other fields | High correlation |
Payment Method Type is highly overall correlated with Card Brand and 5 other fields | High correlation |
Processor Fees is highly overall correlated with Merchant Processor Type and 2 other fields | High correlation |
Processor Response Message is highly overall correlated with Gateway Net Settled Amount and 4 other fields | High correlation |
Transaction Amount is highly overall correlated with Gateway Net Settled Amount and 3 other fields | High correlation |
Transaction Currency is highly overall correlated with Merchant Account ID | High correlation |
Transaction Status is highly overall correlated with Processor Response Message and 1 other fields | High correlation |
Transaction Type is highly overall correlated with Gateway Net Settled Amount and 4 other fields | High correlation |
Transaction Type is highly imbalanced (68.6%) | Imbalance |
Transaction Status is highly imbalanced (82.3%) | Imbalance |
Processor Response Message is highly imbalanced (68.6%) | Imbalance |
Card Brand has 93954 (66.5%) missing values | Missing |
Card Last 4 Digits has 93954 (66.5%) missing values | Missing |
Bank Name has 94406 (66.8%) missing values | Missing |
Bank Account Type has 94406 (66.8%) missing values | Missing |
Payment Method Token has 46844 (33.2%) missing values | Missing |
AVS Result Code has 93954 (66.5%) missing values | Missing |
CVV/CVC Result Code has 93954 (66.5%) missing values | Missing |
Acquirer Reference Number (ARN) has 93954 (66.5%) missing values | Missing |
Merchant Order ID has unique values | Unique |
Processor Response Code is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Processor Fees has 93954 (66.5%) zeros | Zeros |
Reproduction
| Analysis started | 2025-07-06 23:53:35.536307 |
|---|---|
| Analysis finished | 2025-07-06 23:53:43.121504 |
| Duration | 7.59 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
| Distinct | 141176 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.9 MiB |
Length
| Max length | 17 |
|---|---|
| Median length | 17 |
| Mean length | 17 |
| Min length | 17 |
Unique
| Unique | 141102 ? |
|---|---|
| Unique (%) | 99.9% |
Sample
| 1st row | PROC-TRX-96148747 |
|---|---|
| 2nd row | PROC-TRX-53756634 |
| 3rd row | PROC-TRX-96643401 |
| 4th row | PROC-TRX-48503361 |
| 5th row | PROC-TRX-87613870 |
| Value | Count | Frequency (%) |
| proc-trx-62682136 | 2 | < 0.1% |
| proc-trx-20751798 | 2 | < 0.1% |
| proc-trx-79438389 | 2 | < 0.1% |
| proc-trx-25755157 | 2 | < 0.1% |
| proc-trx-59325275 | 2 | < 0.1% |
| proc-trx-11723443 | 2 | < 0.1% |
| proc-trx-64419314 | 2 | < 0.1% |
| proc-trx-46097790 | 2 | < 0.1% |
| proc-trx-34038773 | 2 | < 0.1% |
| proc-trx-31233803 | 2 | < 0.1% |
| Other values (141166) | 141230 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 282500 | 11.8% |
| R | 282500 | 11.8% |
| P | 141250 | 5.9% |
| O | 141250 | 5.9% |
| C | 141250 | 5.9% |
| T | 141250 | 5.9% |
| X | 141250 | 5.9% |
| 4 | 115131 | 4.8% |
| 8 | 114808 | 4.8% |
| 2 | 114778 | 4.8% |
| Other values (7) | 785283 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2401250 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 282500 | 11.8% |
| R | 282500 | 11.8% |
| P | 141250 | 5.9% |
| O | 141250 | 5.9% |
| C | 141250 | 5.9% |
| T | 141250 | 5.9% |
| X | 141250 | 5.9% |
| 4 | 115131 | 4.8% |
| 8 | 114808 | 4.8% |
| 2 | 114778 | 4.8% |
| Other values (7) | 785283 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2401250 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 282500 | 11.8% |
| R | 282500 | 11.8% |
| P | 141250 | 5.9% |
| O | 141250 | 5.9% |
| C | 141250 | 5.9% |
| T | 141250 | 5.9% |
| X | 141250 | 5.9% |
| 4 | 115131 | 4.8% |
| 8 | 114808 | 4.8% |
| 2 | 114778 | 4.8% |
| Other values (7) | 785283 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2401250 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 282500 | 11.8% |
| R | 282500 | 11.8% |
| P | 141250 | 5.9% |
| O | 141250 | 5.9% |
| C | 141250 | 5.9% |
| T | 141250 | 5.9% |
| X | 141250 | 5.9% |
| 4 | 115131 | 4.8% |
| 8 | 114808 | 4.8% |
| 2 | 114778 | 4.8% |
| Other values (7) | 785283 |
Merchant Account ID
Categorical
High correlation 
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.2 MiB |
| MERCH_CYBERSOURCE_USD | |
|---|---|
| MERCH_GOCARDLESS_USD | |
| MERCH_PAYPAL_USD | |
| MERCH_CYBERSOURCE_EUR | |
| MERCH_PAYPAL_EUR | |
| Other values (10) |
Length
| Max length | 21 |
|---|---|
| Median length | 20 |
| Mean length | 19.00075 |
| Min length | 16 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | MERCH_PAYPAL_USD |
|---|---|
| 2nd row | MERCH_GOCARDLESS_USD |
| 3rd row | MERCH_GOCARDLESS_USD |
| 4th row | MERCH_CYBERSOURCE_GBP |
| 5th row | MERCH_PAYPAL_USD |
Common Values
| Value | Count | Frequency (%) |
| MERCH_CYBERSOURCE_USD | 28475 | |
| MERCH_GOCARDLESS_USD | 28156 | |
| MERCH_PAYPAL_USD | 28153 | |
| MERCH_CYBERSOURCE_EUR | 7097 | 5.0% |
| MERCH_PAYPAL_EUR | 6988 | 4.9% |
| MERCH_GOCARDLESS_EUR | 6917 | 4.9% |
| MERCH_PAYPAL_GBP | 4764 | 3.4% |
| MERCH_GOCARDLESS_GBP | 4711 | 3.3% |
| MERCH_CYBERSOURCE_GBP | 4625 | 3.3% |
| MERCH_PAYPAL_AUD | 3841 | 2.7% |
| Other values (5) | 17523 |
Length
| Value | Count | Frequency (%) |
| merch_cybersource_usd | 28475 | |
| merch_gocardless_usd | 28156 | |
| merch_paypal_usd | 28153 | |
| merch_cybersource_eur | 7097 | 5.0% |
| merch_paypal_eur | 6988 | 4.9% |
| merch_gocardless_eur | 6917 | 4.9% |
| merch_paypal_gbp | 4764 | 3.4% |
| merch_gocardless_gbp | 4711 | 3.3% |
| merch_cybersource_gbp | 4625 | 3.3% |
| merch_paypal_aud | 3841 | 2.7% |
| Other values (5) | 17523 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 303688 | |
| R | 303688 | |
| C | 292634 | |
| _ | 282500 | |
| S | 225768 | |
| U | 164498 | 6.1% |
| A | 162428 | 6.1% |
| D | 152992 | 5.7% |
| M | 141250 | 5.3% |
| H | 141250 | 5.3% |
| Other values (6) | 513160 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2683856 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 303688 | |
| R | 303688 | |
| C | 292634 | |
| _ | 282500 | |
| S | 225768 | |
| U | 164498 | 6.1% |
| A | 162428 | 6.1% |
| D | 152992 | 5.7% |
| M | 141250 | 5.3% |
| H | 141250 | 5.3% |
| Other values (6) | 513160 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2683856 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 303688 | |
| R | 303688 | |
| C | 292634 | |
| _ | 282500 | |
| S | 225768 | |
| U | 164498 | 6.1% |
| A | 162428 | 6.1% |
| D | 152992 | 5.7% |
| M | 141250 | 5.3% |
| H | 141250 | 5.3% |
| Other values (6) | 513160 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2683856 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 303688 | |
| R | 303688 | |
| C | 292634 | |
| _ | 282500 | |
| S | 225768 | |
| U | 164498 | 6.1% |
| A | 162428 | 6.1% |
| D | 152992 | 5.7% |
| M | 141250 | 5.3% |
| H | 141250 | 5.3% |
| Other values (6) | 513160 |
Merchant Processor Type
Categorical
High correlation 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.7 MiB |
| PayPal | |
|---|---|
| GoCardless | |
| ClientLine | |
| Amex |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 8.0016 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PayPal |
|---|---|
| 2nd row | GoCardless |
| 3rd row | GoCardless |
| 4th row | ClientLine |
| 5th row | PayPal |
Common Values
| Value | Count | Frequency (%) |
| PayPal | 47110 | |
| GoCardless | 46844 | |
| ClientLine | 31657 | |
| Amex | 15639 | 11.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| paypal | 47110 | |
| gocardless | 46844 | |
| clientline | 31657 | |
| amex | 15639 | 11.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 141064 | |
| e | 125797 | |
| l | 125611 | |
| P | 94220 | 8.3% |
| s | 93688 | 8.3% |
| C | 78501 | 6.9% |
| i | 63314 | 5.6% |
| n | 63314 | 5.6% |
| y | 47110 | 4.2% |
| G | 46844 | 4.1% |
| Other values (8) | 250763 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1130226 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 141064 | |
| e | 125797 | |
| l | 125611 | |
| P | 94220 | 8.3% |
| s | 93688 | 8.3% |
| C | 78501 | 6.9% |
| i | 63314 | 5.6% |
| n | 63314 | 5.6% |
| y | 47110 | 4.2% |
| G | 46844 | 4.1% |
| Other values (8) | 250763 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1130226 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 141064 | |
| e | 125797 | |
| l | 125611 | |
| P | 94220 | 8.3% |
| s | 93688 | 8.3% |
| C | 78501 | 6.9% |
| i | 63314 | 5.6% |
| n | 63314 | 5.6% |
| y | 47110 | 4.2% |
| G | 46844 | 4.1% |
| Other values (8) | 250763 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1130226 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 141064 | |
| e | 125797 | |
| l | 125611 | |
| P | 94220 | 8.3% |
| s | 93688 | 8.3% |
| C | 78501 | 6.9% |
| i | 63314 | 5.6% |
| n | 63314 | 5.6% |
| y | 47110 | 4.2% |
| G | 46844 | 4.1% |
| Other values (8) | 250763 |
Transaction Type
Categorical
High correlation  Imbalance 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.6 MiB |
| payment | |
|---|---|
| refund | 12500 |
| chargeback | 2500 |
| chargeback_reversal | 1250 |
Length
| Max length | 19 |
|---|---|
| Median length | 7 |
| Mean length | 7.0707965 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | payment |
|---|---|
| 2nd row | payment |
| 3rd row | payment |
| 4th row | payment |
| 5th row | payment |
Common Values
| Value | Count | Frequency (%) |
| payment | 125000 | |
| refund | 12500 | 8.8% |
| chargeback | 2500 | 1.8% |
| chargeback_reversal | 1250 | 0.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| payment | 125000 | |
| refund | 12500 | 8.8% |
| chargeback | 2500 | 1.8% |
| chargeback_reversal | 1250 | 0.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 143750 | |
| n | 137500 | |
| a | 133750 | |
| p | 125000 | |
| y | 125000 | |
| m | 125000 | |
| t | 125000 | |
| r | 18750 | 1.9% |
| u | 12500 | 1.3% |
| d | 12500 | 1.3% |
| Other values (10) | 40000 | 4.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 998750 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 143750 | |
| n | 137500 | |
| a | 133750 | |
| p | 125000 | |
| y | 125000 | |
| m | 125000 | |
| t | 125000 | |
| r | 18750 | 1.9% |
| u | 12500 | 1.3% |
| d | 12500 | 1.3% |
| Other values (10) | 40000 | 4.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 998750 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 143750 | |
| n | 137500 | |
| a | 133750 | |
| p | 125000 | |
| y | 125000 | |
| m | 125000 | |
| t | 125000 | |
| r | 18750 | 1.9% |
| u | 12500 | 1.3% |
| d | 12500 | 1.3% |
| Other values (10) | 40000 | 4.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 998750 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 143750 | |
| n | 137500 | |
| a | 133750 | |
| p | 125000 | |
| y | 125000 | |
| m | 125000 | |
| t | 125000 | |
| r | 18750 | 1.9% |
| u | 12500 | 1.3% |
| d | 12500 | 1.3% |
| Other values (10) | 40000 | 4.0% |
Transaction Status
Categorical
High correlation  Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.5 MiB |
| settled | |
|---|---|
| disputed | 3750 |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 7.0265487 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | settled |
|---|---|
| 2nd row | settled |
| 3rd row | settled |
| 4th row | settled |
| 5th row | settled |
Common Values
| Value | Count | Frequency (%) |
| settled | 137500 | |
| disputed | 3750 | 2.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| settled | 137500 | |
| disputed | 3750 | 2.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 278750 | |
| t | 278750 | |
| d | 145000 | |
| s | 141250 | |
| l | 137500 | |
| i | 3750 | 0.4% |
| p | 3750 | 0.4% |
| u | 3750 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 992500 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 278750 | |
| t | 278750 | |
| d | 145000 | |
| s | 141250 | |
| l | 137500 | |
| i | 3750 | 0.4% |
| p | 3750 | 0.4% |
| u | 3750 | 0.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 992500 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 278750 | |
| t | 278750 | |
| d | 145000 | |
| s | 141250 | |
| l | 137500 | |
| i | 3750 | 0.4% |
| p | 3750 | 0.4% |
| u | 3750 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 992500 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 278750 | |
| t | 278750 | |
| d | 145000 | |
| s | 141250 | |
| l | 137500 | |
| i | 3750 | 0.4% |
| p | 3750 | 0.4% |
| u | 3750 | 0.4% |
Transaction Amount
Real number (ℝ)
High correlation 
| Distinct | 122801 |
|---|---|
| Distinct (%) | 86.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1979.2208 |
| Minimum | -4999.85 |
|---|---|
| Maximum | 4999.87 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 15000 |
| Negative (%) | 10.6% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | -4999.85 |
|---|---|
| 5-th percentile | -2655.288 |
| Q1 | 828.465 |
| median | 2221.17 |
| Q3 | 3607.4425 |
| 95-th percentile | 4724.491 |
| Maximum | 4999.87 |
| Range | 9999.72 |
| Interquartile range (IQR) | 2778.9775 |
Descriptive statistics
| Standard deviation | 2112.685 |
|---|---|
| Coefficient of variation (CV) | 1.0674327 |
| Kurtosis | 1.0466637 |
| Mean | 1979.2208 |
| Median Absolute Deviation (MAD) | 1389.74 |
| Skewness | -1.0062879 |
| Sum | 2.7956493 × 108 |
| Variance | 4463437.9 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4756.12 | 5 | < 0.1% |
| 953.97 | 5 | < 0.1% |
| 931.3 | 5 | < 0.1% |
| 3543.24 | 5 | < 0.1% |
| 4146.9 | 5 | < 0.1% |
| 1020.37 | 5 | < 0.1% |
| 1902 | 5 | < 0.1% |
| 2595.9 | 5 | < 0.1% |
| 1121 | 4 | < 0.1% |
| 4540.24 | 4 | < 0.1% |
| Other values (122791) | 141202 |
| Value | Count | Frequency (%) |
| -4999.85 | 1 | |
| -4999.06 | 1 | |
| -4998.84 | 2 | |
| -4998.76 | 1 | |
| -4998.23 | 1 | |
| -4996.55 | 2 | |
| -4996.24 | 1 | |
| -4996.23 | 2 | |
| -4996.21 | 2 | |
| -4995.93 | 1 |
| Value | Count | Frequency (%) |
| 4999.87 | 1 | |
| 4999.85 | 2 | |
| 4999.66 | 1 | |
| 4999.61 | 1 | |
| 4999.54 | 1 | |
| 4999.44 | 1 | |
| 4999.28 | 2 | |
| 4999.27 | 1 | |
| 4999.26 | 1 | |
| 4999.24 | 1 |
Transaction Currency
Categorical
High correlation 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.0 MiB |
| USD | |
|---|---|
| EUR | |
| GBP | |
| AUD | |
| CAD |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | USD |
|---|---|
| 2nd row | USD |
| 3rd row | USD |
| 4th row | GBP |
| 5th row | USD |
Common Values
| Value | Count | Frequency (%) |
| USD | 84784 | |
| EUR | 21002 | 14.9% |
| GBP | 14100 | 10.0% |
| AUD | 11416 | 8.1% |
| CAD | 9948 | 7.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| usd | 84784 | |
| eur | 21002 | 14.9% |
| gbp | 14100 | 10.0% |
| aud | 11416 | 8.1% |
| cad | 9948 | 7.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 117202 | |
| D | 106148 | |
| S | 84784 | |
| A | 21364 | 5.0% |
| E | 21002 | 5.0% |
| R | 21002 | 5.0% |
| G | 14100 | 3.3% |
| B | 14100 | 3.3% |
| P | 14100 | 3.3% |
| C | 9948 | 2.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 423750 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| U | 117202 | |
| D | 106148 | |
| S | 84784 | |
| A | 21364 | 5.0% |
| E | 21002 | 5.0% |
| R | 21002 | 5.0% |
| G | 14100 | 3.3% |
| B | 14100 | 3.3% |
| P | 14100 | 3.3% |
| C | 9948 | 2.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 423750 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| U | 117202 | |
| D | 106148 | |
| S | 84784 | |
| A | 21364 | 5.0% |
| E | 21002 | 5.0% |
| R | 21002 | 5.0% |
| G | 14100 | 3.3% |
| B | 14100 | 3.3% |
| P | 14100 | 3.3% |
| C | 9948 | 2.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 423750 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| U | 117202 | |
| D | 106148 | |
| S | 84784 | |
| A | 21364 | 5.0% |
| E | 21002 | 5.0% |
| R | 21002 | 5.0% |
| G | 14100 | 3.3% |
| B | 14100 | 3.3% |
| P | 14100 | 3.3% |
| C | 9948 | 2.3% |
Processor Response Code
Unsupported
Rejected  Unsupported 
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 5.2 MiB |
Processor Response Message
Categorical
High correlation  Imbalance 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.8 MiB |
| Approved | |
|---|---|
| Refund Processed | 12500 |
| Chargeback Initiated | 2500 |
| Chargeback Reversed | 1250 |
Length
| Max length | 20 |
|---|---|
| Median length | 8 |
| Mean length | 9.0176991 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Approved |
|---|---|
| 2nd row | Approved |
| 3rd row | Approved |
| 4th row | Approved |
| 5th row | Approved |
Common Values
| Value | Count | Frequency (%) |
| Approved | 125000 | |
| Refund Processed | 12500 | 8.8% |
| Chargeback Initiated | 2500 | 1.8% |
| Chargeback Reversed | 1250 | 0.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| approved | 125000 | |
| refund | 12500 | 7.9% |
| processed | 12500 | 7.9% |
| chargeback | 3750 | 2.4% |
| initiated | 2500 | 1.6% |
| reversed | 1250 | 0.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| p | 250000 | |
| e | 172500 | |
| d | 153750 | |
| r | 142500 | |
| o | 137500 | |
| v | 126250 | |
| A | 125000 | |
| s | 26250 | 2.1% |
| c | 16250 | 1.3% |
| 16250 | 1.3% | |
| Other values (14) | 107500 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1273750 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| p | 250000 | |
| e | 172500 | |
| d | 153750 | |
| r | 142500 | |
| o | 137500 | |
| v | 126250 | |
| A | 125000 | |
| s | 26250 | 2.1% |
| c | 16250 | 1.3% |
| 16250 | 1.3% | |
| Other values (14) | 107500 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1273750 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| p | 250000 | |
| e | 172500 | |
| d | 153750 | |
| r | 142500 | |
| o | 137500 | |
| v | 126250 | |
| A | 125000 | |
| s | 26250 | 2.1% |
| c | 16250 | 1.3% |
| 16250 | 1.3% | |
| Other values (14) | 107500 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1273750 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| p | 250000 | |
| e | 172500 | |
| d | 153750 | |
| r | 142500 | |
| o | 137500 | |
| v | 126250 | |
| A | 125000 | |
| s | 26250 | 2.1% |
| c | 16250 | 1.3% |
| 16250 | 1.3% | |
| Other values (14) | 107500 |
Payment Method Type
Categorical
High correlation 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.5 MiB |
| Credit Card | |
|---|---|
| PayPal | |
| ACH |
Length
| Max length | 11 |
|---|---|
| Median length | 6 |
| Mean length | 6.6792779 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PayPal |
|---|---|
| 2nd row | ACH |
| 3rd row | ACH |
| 4th row | Credit Card |
| 5th row | PayPal |
Common Values
| Value | Count | Frequency (%) |
| Credit Card | 47296 | |
| PayPal | 47110 | |
| ACH | 46844 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| credit | 47296 | |
| card | 47296 | |
| paypal | 47110 | |
| ach | 46844 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 141516 | |
| C | 141436 | |
| r | 94592 | |
| d | 94592 | |
| P | 94220 | |
| e | 47296 | 5.0% |
| i | 47296 | 5.0% |
| t | 47296 | 5.0% |
| 47296 | 5.0% | |
| y | 47110 | 5.0% |
| Other values (3) | 140798 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 943448 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 141516 | |
| C | 141436 | |
| r | 94592 | |
| d | 94592 | |
| P | 94220 | |
| e | 47296 | 5.0% |
| i | 47296 | 5.0% |
| t | 47296 | 5.0% |
| 47296 | 5.0% | |
| y | 47110 | 5.0% |
| Other values (3) | 140798 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 943448 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 141516 | |
| C | 141436 | |
| r | 94592 | |
| d | 94592 | |
| P | 94220 | |
| e | 47296 | 5.0% |
| i | 47296 | 5.0% |
| t | 47296 | 5.0% |
| 47296 | 5.0% | |
| y | 47110 | 5.0% |
| Other values (3) | 140798 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 943448 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 141516 | |
| C | 141436 | |
| r | 94592 | |
| d | 94592 | |
| P | 94220 | |
| e | 47296 | 5.0% |
| i | 47296 | 5.0% |
| t | 47296 | 5.0% |
| 47296 | 5.0% | |
| y | 47110 | 5.0% |
| Other values (3) | 140798 |
Card Brand
Categorical
High correlation  Missing 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 93954 |
| Missing (%) | 66.5% |
| Memory size | 7.5 MiB |
| Mastercard | |
|---|---|
| Visa | |
| Amex |
Length
| Max length | 10 |
|---|---|
| Median length | 4 |
| Mean length | 6.0246955 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Visa |
|---|---|
| 2nd row | Mastercard |
| 3rd row | Amex |
| 4th row | Mastercard |
| 5th row | Visa |
Common Values
| Value | Count | Frequency (%) |
| Mastercard | 15960 | 11.3% |
| Visa | 15697 | 11.1% |
| Amex | 15639 | 11.1% |
| (Missing) | 93954 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| mastercard | 15960 | |
| visa | 15697 | |
| amex | 15639 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 47617 | |
| r | 31920 | |
| s | 31657 | |
| e | 31599 | |
| M | 15960 | 5.6% |
| t | 15960 | 5.6% |
| c | 15960 | 5.6% |
| d | 15960 | 5.6% |
| V | 15697 | 5.5% |
| i | 15697 | 5.5% |
| Other values (3) | 46917 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 284944 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 47617 | |
| r | 31920 | |
| s | 31657 | |
| e | 31599 | |
| M | 15960 | 5.6% |
| t | 15960 | 5.6% |
| c | 15960 | 5.6% |
| d | 15960 | 5.6% |
| V | 15697 | 5.5% |
| i | 15697 | 5.5% |
| Other values (3) | 46917 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 284944 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 47617 | |
| r | 31920 | |
| s | 31657 | |
| e | 31599 | |
| M | 15960 | 5.6% |
| t | 15960 | 5.6% |
| c | 15960 | 5.6% |
| d | 15960 | 5.6% |
| V | 15697 | 5.5% |
| i | 15697 | 5.5% |
| Other values (3) | 46917 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 284944 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 47617 | |
| r | 31920 | |
| s | 31657 | |
| e | 31599 | |
| M | 15960 | 5.6% |
| t | 15960 | 5.6% |
| c | 15960 | 5.6% |
| d | 15960 | 5.6% |
| V | 15697 | 5.5% |
| i | 15697 | 5.5% |
| Other values (3) | 46917 |
Card Last 4 Digits
Real number (ℝ)
High correlation  Missing 
| Distinct | 8963 |
|---|---|
| Distinct (%) | 19.0% |
| Missing | 93954 |
| Missing (%) | 66.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5511.9391 |
| Minimum | 1000 |
|---|---|
| Maximum | 9999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 1000 |
|---|---|
| 5-th percentile | 1459.75 |
| Q1 | 3267 |
| median | 5540.5 |
| Q3 | 7743.25 |
| 95-th percentile | 9541 |
| Maximum | 9999 |
| Range | 8999 |
| Interquartile range (IQR) | 4476.25 |
Descriptive statistics
| Standard deviation | 2588.5975 |
|---|---|
| Coefficient of variation (CV) | 0.46963463 |
| Kurtosis | -1.1929835 |
| Mean | 5511.9391 |
| Median Absolute Deviation (MAD) | 2238.5 |
| Skewness | -0.0087537714 |
| Sum | 2.6069267 × 108 |
| Variance | 6700836.9 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5062 | 16 | < 0.1% |
| 2609 | 15 | < 0.1% |
| 9615 | 15 | < 0.1% |
| 9126 | 15 | < 0.1% |
| 9930 | 15 | < 0.1% |
| 7952 | 14 | < 0.1% |
| 6197 | 14 | < 0.1% |
| 4571 | 14 | < 0.1% |
| 3207 | 14 | < 0.1% |
| 3872 | 14 | < 0.1% |
| Other values (8953) | 47150 | |
| (Missing) | 93954 |
| Value | Count | Frequency (%) |
| 1000 | 3 | |
| 1001 | 4 | |
| 1002 | 3 | |
| 1003 | 4 | |
| 1004 | 3 | |
| 1005 | 5 | |
| 1006 | 7 | |
| 1007 | 5 | |
| 1008 | 3 | |
| 1009 | 6 |
| Value | Count | Frequency (%) |
| 9999 | 7 | |
| 9998 | 8 | |
| 9997 | 7 | |
| 9996 | 5 | |
| 9995 | 5 | |
| 9994 | 6 | |
| 9993 | 5 | |
| 9992 | 7 | |
| 9991 | 8 | |
| 9990 | 7 |
Card Expiration Date
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.3 MiB |
| 12/28 |
|---|
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 12/28 |
|---|---|
| 2nd row | 12/28 |
| 3rd row | 12/28 |
| 4th row | 12/28 |
| 5th row | 12/28 |
Common Values
| Value | Count | Frequency (%) |
| 12/28 | 141250 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 12/28 | 141250 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 282500 | |
| 1 | 141250 | |
| / | 141250 | |
| 8 | 141250 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 706250 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 282500 | |
| 1 | 141250 | |
| / | 141250 | |
| 8 | 141250 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 706250 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 282500 | |
| 1 | 141250 | |
| / | 141250 | |
| 8 | 141250 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 706250 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 282500 | |
| 1 | 141250 | |
| / | 141250 | |
| 8 | 141250 |
Bank Name
Categorical
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 94406 |
| Missing (%) | 66.8% |
| Memory size | 7.9 MiB |
| Bank of Example |
|---|
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 15 |
| Min length | 15 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Bank of Example |
|---|---|
| 2nd row | Bank of Example |
| 3rd row | Bank of Example |
| 4th row | Bank of Example |
| 5th row | Bank of Example |
Common Values
| Value | Count | Frequency (%) |
| Bank of Example | 46844 | |
| (Missing) | 94406 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| bank | 46844 | |
| of | 46844 | |
| example | 46844 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 93688 | |
| 93688 | ||
| B | 46844 | 6.7% |
| n | 46844 | 6.7% |
| k | 46844 | 6.7% |
| o | 46844 | 6.7% |
| f | 46844 | 6.7% |
| E | 46844 | 6.7% |
| x | 46844 | 6.7% |
| m | 46844 | 6.7% |
| Other values (3) | 140532 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 702660 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 93688 | |
| 93688 | ||
| B | 46844 | 6.7% |
| n | 46844 | 6.7% |
| k | 46844 | 6.7% |
| o | 46844 | 6.7% |
| f | 46844 | 6.7% |
| E | 46844 | 6.7% |
| x | 46844 | 6.7% |
| m | 46844 | 6.7% |
| Other values (3) | 140532 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 702660 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 93688 | |
| 93688 | ||
| B | 46844 | 6.7% |
| n | 46844 | 6.7% |
| k | 46844 | 6.7% |
| o | 46844 | 6.7% |
| f | 46844 | 6.7% |
| E | 46844 | 6.7% |
| x | 46844 | 6.7% |
| m | 46844 | 6.7% |
| Other values (3) | 140532 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 702660 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 93688 | |
| 93688 | ||
| B | 46844 | 6.7% |
| n | 46844 | 6.7% |
| k | 46844 | 6.7% |
| o | 46844 | 6.7% |
| f | 46844 | 6.7% |
| E | 46844 | 6.7% |
| x | 46844 | 6.7% |
| m | 46844 | 6.7% |
| Other values (3) | 140532 |
Bank Account Type
Categorical
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 94406 |
| Missing (%) | 66.8% |
| Memory size | 7.6 MiB |
| Checking |
|---|
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Checking |
|---|---|
| 2nd row | Checking |
| 3rd row | Checking |
| 4th row | Checking |
| 5th row | Checking |
Common Values
| Value | Count | Frequency (%) |
| Checking | 46844 | |
| (Missing) | 94406 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| checking | 46844 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 46844 | |
| h | 46844 | |
| e | 46844 | |
| c | 46844 | |
| k | 46844 | |
| i | 46844 | |
| n | 46844 | |
| g | 46844 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 374752 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| C | 46844 | |
| h | 46844 | |
| e | 46844 | |
| c | 46844 | |
| k | 46844 | |
| i | 46844 | |
| n | 46844 | |
| g | 46844 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 374752 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| C | 46844 | |
| h | 46844 | |
| e | 46844 | |
| c | 46844 | |
| k | 46844 | |
| i | 46844 | |
| n | 46844 | |
| g | 46844 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 374752 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| C | 46844 | |
| h | 46844 | |
| e | 46844 | |
| c | 46844 | |
| k | 46844 | |
| i | 46844 | |
| n | 46844 | |
| g | 46844 |
Missing 
| Distinct | 89597 |
|---|---|
| Distinct (%) | 94.9% |
| Missing | 46844 |
| Missing (%) | 33.2% |
| Memory size | 6.7 MiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 84954 ? |
|---|---|
| Unique (%) | 90.0% |
Sample
| 1st row | TOK_850912 |
|---|---|
| 2nd row | TOK_268155 |
| 3rd row | TOK_866077 |
| 4th row | TOK_244127 |
| 5th row | TOK_513827 |
| Value | Count | Frequency (%) |
| tok_962548 | 4 | < 0.1% |
| tok_646979 | 4 | < 0.1% |
| tok_257937 | 4 | < 0.1% |
| tok_974943 | 4 | < 0.1% |
| tok_820511 | 4 | < 0.1% |
| tok_973529 | 4 | < 0.1% |
| tok_769620 | 4 | < 0.1% |
| tok_426828 | 3 | < 0.1% |
| tok_848212 | 3 | < 0.1% |
| tok_265257 | 3 | < 0.1% |
| Other values (89587) | 94369 |
Most occurring characters
| Value | Count | Frequency (%) |
| T | 94406 | |
| O | 94406 | |
| K | 94406 | |
| _ | 94406 | |
| 4 | 58303 | 6.2% |
| 2 | 57878 | 6.1% |
| 7 | 57825 | 6.1% |
| 1 | 57804 | 6.1% |
| 9 | 57751 | 6.1% |
| 8 | 57626 | 6.1% |
| Other values (4) | 219249 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 944060 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| T | 94406 | |
| O | 94406 | |
| K | 94406 | |
| _ | 94406 | |
| 4 | 58303 | 6.2% |
| 2 | 57878 | 6.1% |
| 7 | 57825 | 6.1% |
| 1 | 57804 | 6.1% |
| 9 | 57751 | 6.1% |
| 8 | 57626 | 6.1% |
| Other values (4) | 219249 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 944060 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| T | 94406 | |
| O | 94406 | |
| K | 94406 | |
| _ | 94406 | |
| 4 | 58303 | 6.2% |
| 2 | 57878 | 6.1% |
| 7 | 57825 | 6.1% |
| 1 | 57804 | 6.1% |
| 9 | 57751 | 6.1% |
| 8 | 57626 | 6.1% |
| Other values (4) | 219249 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 944060 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| T | 94406 | |
| O | 94406 | |
| K | 94406 | |
| _ | 94406 | |
| 4 | 58303 | 6.2% |
| 2 | 57878 | 6.1% |
| 7 | 57825 | 6.1% |
| 1 | 57804 | 6.1% |
| 9 | 57751 | 6.1% |
| 8 | 57626 | 6.1% |
| Other values (4) | 219249 |
Unique 
| Distinct | 141250 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.1 MiB |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 11 |
| Min length | 11 |
Unique
| Unique | 141250 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | PAY-0000000 |
|---|---|
| 2nd row | PAY-0000001 |
| 3rd row | PAY-0000002 |
| 4th row | PAY-0000003 |
| 5th row | PAY-0000004 |
| Value | Count | Frequency (%) |
| pay-0000000 | 1 | < 0.1% |
| pay-0000011 | 1 | < 0.1% |
| pay-0000017 | 1 | < 0.1% |
| pay-0000016 | 1 | < 0.1% |
| pay-0000015 | 1 | < 0.1% |
| pay-0000014 | 1 | < 0.1% |
| pay-0000013 | 1 | < 0.1% |
| pay-0000012 | 1 | < 0.1% |
| pay-0000010 | 1 | < 0.1% |
| pay-0000070 | 1 | < 0.1% |
| Other values (141240) | 141240 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 334091 | |
| - | 141250 | |
| P | 125000 | 8.0% |
| Y | 125000 | 8.0% |
| A | 125000 | 8.0% |
| 1 | 107672 | 6.9% |
| 2 | 73838 | 4.8% |
| 4 | 68511 | 4.4% |
| 3 | 68239 | 4.4% |
| 5 | 67331 | 4.3% |
| Other values (11) | 317818 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1553750 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 334091 | |
| - | 141250 | |
| P | 125000 | 8.0% |
| Y | 125000 | 8.0% |
| A | 125000 | 8.0% |
| 1 | 107672 | 6.9% |
| 2 | 73838 | 4.8% |
| 4 | 68511 | 4.4% |
| 3 | 68239 | 4.4% |
| 5 | 67331 | 4.3% |
| Other values (11) | 317818 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1553750 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 334091 | |
| - | 141250 | |
| P | 125000 | 8.0% |
| Y | 125000 | 8.0% |
| A | 125000 | 8.0% |
| 1 | 107672 | 6.9% |
| 2 | 73838 | 4.8% |
| 4 | 68511 | 4.4% |
| 3 | 68239 | 4.4% |
| 5 | 67331 | 4.3% |
| Other values (11) | 317818 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1553750 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 334091 | |
| - | 141250 | |
| P | 125000 | 8.0% |
| Y | 125000 | 8.0% |
| A | 125000 | 8.0% |
| 1 | 107672 | 6.9% |
| 2 | 73838 | 4.8% |
| 4 | 68511 | 4.4% |
| 3 | 68239 | 4.4% |
| 5 | 67331 | 4.3% |
| Other values (11) | 317818 |
Customer ID
Text
| Distinct | 9000 |
|---|---|
| Distinct (%) | 6.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.5 MiB |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 14 |
| Min length | 14 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CUST-PROC-2479 |
|---|---|
| 2nd row | CUST-PROC-4051 |
| 3rd row | CUST-PROC-4566 |
| 4th row | CUST-PROC-4425 |
| 5th row | CUST-PROC-1238 |
| Value | Count | Frequency (%) |
| cust-proc-1707 | 32 | < 0.1% |
| cust-proc-7936 | 31 | < 0.1% |
| cust-proc-9420 | 31 | < 0.1% |
| cust-proc-6208 | 30 | < 0.1% |
| cust-proc-4665 | 30 | < 0.1% |
| cust-proc-4237 | 29 | < 0.1% |
| cust-proc-7787 | 29 | < 0.1% |
| cust-proc-7756 | 29 | < 0.1% |
| cust-proc-3780 | 29 | < 0.1% |
| cust-proc-6749 | 29 | < 0.1% |
| Other values (8990) | 140951 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 282500 | |
| - | 282500 | |
| U | 141250 | 7.1% |
| S | 141250 | 7.1% |
| T | 141250 | 7.1% |
| P | 141250 | 7.1% |
| R | 141250 | 7.1% |
| O | 141250 | 7.1% |
| 4 | 58176 | 2.9% |
| 7 | 58165 | 2.9% |
| Other values (8) | 448659 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1977500 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| C | 282500 | |
| - | 282500 | |
| U | 141250 | 7.1% |
| S | 141250 | 7.1% |
| T | 141250 | 7.1% |
| P | 141250 | 7.1% |
| R | 141250 | 7.1% |
| O | 141250 | 7.1% |
| 4 | 58176 | 2.9% |
| 7 | 58165 | 2.9% |
| Other values (8) | 448659 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1977500 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| C | 282500 | |
| - | 282500 | |
| U | 141250 | 7.1% |
| S | 141250 | 7.1% |
| T | 141250 | 7.1% |
| P | 141250 | 7.1% |
| R | 141250 | 7.1% |
| O | 141250 | 7.1% |
| 4 | 58176 | 2.9% |
| 7 | 58165 | 2.9% |
| Other values (8) | 448659 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1977500 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| C | 282500 | |
| - | 282500 | |
| U | 141250 | 7.1% |
| S | 141250 | 7.1% |
| T | 141250 | 7.1% |
| P | 141250 | 7.1% |
| R | 141250 | 7.1% |
| O | 141250 | 7.1% |
| 4 | 58176 | 2.9% |
| 7 | 58165 | 2.9% |
| Other values (8) | 448659 |
AVS Result Code
Boolean
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 93954 |
| Missing (%) | 66.5% |
| Memory size | 276.0 KiB |
| True | |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) |
| True | 47296 | |
| (Missing) | 93954 |
CVV/CVC Result Code
Categorical
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 93954 |
| Missing (%) | 66.5% |
| Memory size | 7.3 MiB |
| M |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | M |
|---|---|
| 2nd row | M |
| 3rd row | M |
| 4th row | M |
| 5th row | M |
Common Values
| Value | Count | Frequency (%) |
| M | 47296 | |
| (Missing) | 93954 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| m | 47296 |
Most occurring characters
| Value | Count | Frequency (%) |
| M | 47296 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 47296 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| M | 47296 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 47296 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| M | 47296 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 47296 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| M | 47296 |
Fraud Score
Real number (ℝ)
| Distinct | 1001 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 49.969022 |
| Minimum | 0 |
|---|---|
| Maximum | 100 |
| Zeros | 68 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 25 |
| median | 49.9 |
| Q3 | 75 |
| 95-th percentile | 95 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 50 |
Descriptive statistics
| Standard deviation | 28.884486 |
|---|---|
| Coefficient of variation (CV) | 0.57804785 |
| Kurtosis | -1.2018133 |
| Mean | 49.969022 |
| Median Absolute Deviation (MAD) | 25 |
| Skewness | 0.0038236209 |
| Sum | 7058124.4 |
| Variance | 834.31353 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 38.3 | 181 | 0.1% |
| 64.2 | 178 | 0.1% |
| 31.9 | 178 | 0.1% |
| 38.6 | 176 | 0.1% |
| 70.8 | 175 | 0.1% |
| 0.1 | 175 | 0.1% |
| 80.8 | 174 | 0.1% |
| 22.8 | 173 | 0.1% |
| 89.3 | 173 | 0.1% |
| 63.9 | 170 | 0.1% |
| Other values (991) | 139497 |
| Value | Count | Frequency (%) |
| 0 | 68 | < 0.1% |
| 0.1 | 175 | |
| 0.2 | 143 | |
| 0.3 | 152 | |
| 0.4 | 131 | |
| 0.5 | 147 | |
| 0.6 | 131 | |
| 0.7 | 159 | |
| 0.8 | 150 | |
| 0.9 | 143 |
| Value | Count | Frequency (%) |
| 100 | 77 | |
| 99.9 | 126 | |
| 99.8 | 138 | |
| 99.7 | 144 | |
| 99.6 | 156 | |
| 99.5 | 127 | |
| 99.4 | 155 | |
| 99.3 | 126 | |
| 99.2 | 135 | |
| 99.1 | 139 |
Fraud Action
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.3 MiB |
| allow |
|---|
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | allow |
|---|---|
| 2nd row | allow |
| 3rd row | allow |
| 4th row | allow |
| 5th row | allow |
Common Values
| Value | Count | Frequency (%) |
| allow | 141250 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| allow | 141250 |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 282500 | |
| a | 141250 | |
| o | 141250 | |
| w | 141250 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 706250 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| l | 282500 | |
| a | 141250 | |
| o | 141250 | |
| w | 141250 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 706250 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| l | 282500 | |
| a | 141250 | |
| o | 141250 | |
| w | 141250 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 706250 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| l | 282500 | |
| a | 141250 | |
| o | 141250 | |
| w | 141250 |
Gateway Net Settled Amount
Real number (ℝ)
High correlation 
| Distinct | 124790 |
|---|---|
| Distinct (%) | 88.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1962.4242 |
| Minimum | -5046.2 |
|---|---|
| Maximum | 4987.37 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 15000 |
| Negative (%) | 10.6% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | -5046.2 |
|---|---|
| 5-th percentile | -2672.5785 |
| Q1 | 822.68 |
| median | 2206.12 |
| Q3 | 3583.4875 |
| 95-th percentile | 4692.4065 |
| Maximum | 4987.37 |
| Range | 10033.57 |
| Interquartile range (IQR) | 2760.8075 |
Descriptive statistics
| Standard deviation | 2107.6026 |
|---|---|
| Coefficient of variation (CV) | 1.0739791 |
| Kurtosis | 1.0941128 |
| Mean | 1962.4242 |
| Median Absolute Deviation (MAD) | 1380.015 |
| Skewness | -1.0220654 |
| Sum | 2.7719242 × 108 |
| Variance | 4441988.9 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3385.57 | 5 | < 0.1% |
| 3300.21 | 5 | < 0.1% |
| 2897.74 | 5 | < 0.1% |
| 4796.47 | 5 | < 0.1% |
| 2508.85 | 4 | < 0.1% |
| 740.26 | 4 | < 0.1% |
| 1054.78 | 4 | < 0.1% |
| 1727.27 | 4 | < 0.1% |
| 2273.48 | 4 | < 0.1% |
| 1768.97 | 4 | < 0.1% |
| Other values (124780) | 141206 |
| Value | Count | Frequency (%) |
| -5046.2 | 1 | |
| -5045.89 | 1 | |
| -5045.17 | 1 | |
| -5044.44 | 1 | |
| -5044.03 | 1 | |
| -5042.96 | 1 | |
| -5042.84 | 1 | |
| -5042.64 | 1 | |
| -5039.5 | 1 | |
| -5039.08 | 1 |
| Value | Count | Frequency (%) |
| 4987.37 | 1 | |
| 4987.35 | 1 | |
| 4987.11 | 1 | |
| 4987.04 | 1 | |
| 4986.94 | 1 | |
| 4986.78 | 2 | |
| 4986.68 | 1 | |
| 4986.35 | 1 | |
| 4986.34 | 1 | |
| 4986.23 | 1 |
Processor Fees
Real number (ℝ)
High correlation  Zeros 
| Distinct | 7087 |
|---|---|
| Distinct (%) | 5.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.8112149 |
| Minimum | 0 |
|---|---|
| Maximum | 74.99 |
| Zeros | 93954 |
| Zeros (%) | 66.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 14.46 |
| 95-th percentile | 47.98 |
| Maximum | 74.99 |
| Range | 74.99 |
| Interquartile range (IQR) | 14.46 |
Descriptive statistics
| Standard deviation | 17.32999 |
|---|---|
| Coefficient of variation (CV) | 1.7663449 |
| Kurtosis | 1.9714233 |
| Mean | 9.8112149 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.7263428 |
| Sum | 1385834.1 |
| Variance | 300.32854 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 93954 | |
| 41.01 | 24 | < 0.1% |
| 38.4 | 24 | < 0.1% |
| 15.22 | 24 | < 0.1% |
| 9.17 | 23 | < 0.1% |
| 12.85 | 23 | < 0.1% |
| 9.3 | 23 | < 0.1% |
| 17.81 | 23 | < 0.1% |
| 27.07 | 23 | < 0.1% |
| 28.66 | 22 | < 0.1% |
| Other values (7077) | 47087 |
| Value | Count | Frequency (%) |
| 0 | 93954 | |
| 0.26 | 5 | < 0.1% |
| 0.27 | 9 | < 0.1% |
| 0.28 | 7 | < 0.1% |
| 0.29 | 3 | < 0.1% |
| 0.3 | 10 | < 0.1% |
| 0.31 | 2 | < 0.1% |
| 0.32 | 7 | < 0.1% |
| 0.33 | 7 | < 0.1% |
| 0.34 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 74.99 | 1 | < 0.1% |
| 74.98 | 3 | |
| 74.97 | 2 | < 0.1% |
| 74.95 | 2 | < 0.1% |
| 74.94 | 5 | |
| 74.93 | 4 | |
| 74.92 | 1 | < 0.1% |
| 74.91 | 1 | < 0.1% |
| 74.9 | 2 | < 0.1% |
| 74.89 | 2 | < 0.1% |
Net Amount to Merchant
Real number (ℝ)
High correlation 
| Distinct | 126072 |
|---|---|
| Distinct (%) | 89.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1952.613 |
| Minimum | -5121.14 |
|---|---|
| Maximum | 4987.37 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 15000 |
| Negative (%) | 10.6% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | -5121.14 |
|---|---|
| 5-th percentile | -2686.679 |
| Q1 | 818.9725 |
| median | 2198.58 |
| Q3 | 3568.6375 |
| 95-th percentile | 4673.3085 |
| Maximum | 4987.37 |
| Range | 10108.51 |
| Interquartile range (IQR) | 2749.665 |
Descriptive statistics
| Standard deviation | 2104.7798 |
|---|---|
| Coefficient of variation (CV) | 1.0779298 |
| Kurtosis | 1.1223452 |
| Mean | 1952.613 |
| Median Absolute Deviation (MAD) | 1375.175 |
| Skewness | -1.0310854 |
| Sum | 2.7580658 × 108 |
| Variance | 4430098 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 398.52 | 5 | < 0.1% |
| 3598.04 | 5 | < 0.1% |
| 453.83 | 5 | < 0.1% |
| 4242.54 | 4 | < 0.1% |
| 3644.56 | 4 | < 0.1% |
| 4329.09 | 4 | < 0.1% |
| 1088.79 | 4 | < 0.1% |
| 1003.37 | 4 | < 0.1% |
| 2042.33 | 4 | < 0.1% |
| 257.12 | 4 | < 0.1% |
| Other values (126062) | 141207 |
| Value | Count | Frequency (%) |
| -5121.14 | 1 | |
| -5120.1 | 1 | |
| -5114.34 | 1 | |
| -5112.98 | 1 | |
| -5112.86 | 2 | |
| -5107.75 | 1 | |
| -5097.22 | 1 | |
| -5095.85 | 1 | |
| -5094.91 | 1 | |
| -5094.38 | 1 |
| Value | Count | Frequency (%) |
| 4987.37 | 1 | |
| 4987.35 | 1 | |
| 4987.11 | 1 | |
| 4987.04 | 1 | |
| 4986.94 | 1 | |
| 4986.78 | 2 | |
| 4986.68 | 1 | |
| 4986.35 | 1 | |
| 4986.34 | 1 | |
| 4986.23 | 1 |
| Distinct | 2250 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.6 MiB |
Length
| Max length | 38 |
|---|---|
| Median length | 32 |
| Mean length | 30.014386 |
| Min length | 26 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SET-20250130-PayPal-N/A-USD |
|---|---|
| 2nd row | SET-20250110-GoCardless-N/A-USD |
| 3rd row | SET-20250221-GoCardless-N/A-USD |
| 4th row | SET-20250104-ClientLine-Visa-GBP |
| 5th row | SET-20250316-PayPal-N/A-USD |
| Value | Count | Frequency (%) |
| set-20250102-paypal-n/a-usd | 360 | 0.3% |
| set-20250202-paypal-n/a-usd | 359 | 0.3% |
| set-20250120-paypal-n/a-usd | 352 | 0.2% |
| set-20250314-paypal-n/a-usd | 350 | 0.2% |
| set-20250313-gocardless-n/a-usd | 349 | 0.2% |
| set-20250112-paypal-n/a-usd | 348 | 0.2% |
| set-20250115-gocardless-n/a-usd | 346 | 0.2% |
| set-20250304-paypal-n/a-usd | 345 | 0.2% |
| set-20250316-paypal-n/a-usd | 344 | 0.2% |
| set-20250202-gocardless-n/a-usd | 344 | 0.2% |
| Other values (2240) | 137753 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 565000 | 13.3% |
| 2 | 386343 | 9.1% |
| 0 | 337359 | 8.0% |
| S | 226034 | 5.3% |
| a | 188681 | 4.5% |
| E | 162252 | 3.8% |
| e | 157396 | 3.7% |
| 5 | 155521 | 3.7% |
| A | 146596 | 3.5% |
| T | 141250 | 3.3% |
| Other values (31) | 1773100 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4239532 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 565000 | 13.3% |
| 2 | 386343 | 9.1% |
| 0 | 337359 | 8.0% |
| S | 226034 | 5.3% |
| a | 188681 | 4.5% |
| E | 162252 | 3.8% |
| e | 157396 | 3.7% |
| 5 | 155521 | 3.7% |
| A | 146596 | 3.5% |
| T | 141250 | 3.3% |
| Other values (31) | 1773100 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4239532 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 565000 | 13.3% |
| 2 | 386343 | 9.1% |
| 0 | 337359 | 8.0% |
| S | 226034 | 5.3% |
| a | 188681 | 4.5% |
| E | 162252 | 3.8% |
| e | 157396 | 3.7% |
| 5 | 155521 | 3.7% |
| A | 146596 | 3.5% |
| T | 141250 | 3.3% |
| Other values (31) | 1773100 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4239532 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 565000 | 13.3% |
| 2 | 386343 | 9.1% |
| 0 | 337359 | 8.0% |
| S | 226034 | 5.3% |
| a | 188681 | 4.5% |
| E | 162252 | 3.8% |
| e | 157396 | 3.7% |
| 5 | 155521 | 3.7% |
| A | 146596 | 3.5% |
| T | 141250 | 3.3% |
| Other values (31) | 1773100 |
Settlement Date
Date
| Distinct | 65 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Minimum | 2025-01-02 00:00:00 |
|---|---|
| Maximum | 2025-04-02 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Acquirer Reference Number (ARN)
Text
Missing 
| Distinct | 47296 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 93954 |
| Missing (%) | 66.5% |
| Memory size | 5.6 MiB |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 12 |
| Min length | 12 |
Unique
| Unique | 47296 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | ARN618188908 |
|---|---|
| 2nd row | ARN591055160 |
| 3rd row | ARN184492302 |
| 4th row | ARN314680266 |
| 5th row | ARN615595718 |
| Value | Count | Frequency (%) |
| arn276300877 | 1 | < 0.1% |
| arn213177541 | 1 | < 0.1% |
| arn669849388 | 1 | < 0.1% |
| arn629677896 | 1 | < 0.1% |
| arn591055160 | 1 | < 0.1% |
| arn184492302 | 1 | < 0.1% |
| arn314680266 | 1 | < 0.1% |
| arn615595718 | 1 | < 0.1% |
| arn594832966 | 1 | < 0.1% |
| arn508354528 | 1 | < 0.1% |
| Other values (47286) | 47286 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 47296 | 8.3% |
| R | 47296 | 8.3% |
| N | 47296 | 8.3% |
| 2 | 43333 | 7.6% |
| 3 | 43163 | 7.6% |
| 6 | 43124 | 7.6% |
| 7 | 43103 | 7.6% |
| 9 | 43094 | 7.6% |
| 5 | 43048 | 7.6% |
| 8 | 43038 | 7.6% |
| Other values (3) | 123761 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 567552 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 47296 | 8.3% |
| R | 47296 | 8.3% |
| N | 47296 | 8.3% |
| 2 | 43333 | 7.6% |
| 3 | 43163 | 7.6% |
| 6 | 43124 | 7.6% |
| 7 | 43103 | 7.6% |
| 9 | 43094 | 7.6% |
| 5 | 43048 | 7.6% |
| 8 | 43038 | 7.6% |
| Other values (3) | 123761 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 567552 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 47296 | 8.3% |
| R | 47296 | 8.3% |
| N | 47296 | 8.3% |
| 2 | 43333 | 7.6% |
| 3 | 43163 | 7.6% |
| 6 | 43124 | 7.6% |
| 7 | 43103 | 7.6% |
| 9 | 43094 | 7.6% |
| 5 | 43048 | 7.6% |
| 8 | 43038 | 7.6% |
| Other values (3) | 123761 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 567552 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 47296 | 8.3% |
| R | 47296 | 8.3% |
| N | 47296 | 8.3% |
| 2 | 43333 | 7.6% |
| 3 | 43163 | 7.6% |
| 6 | 43124 | 7.6% |
| 7 | 43103 | 7.6% |
| 9 | 43094 | 7.6% |
| 5 | 43048 | 7.6% |
| 8 | 43038 | 7.6% |
| Other values (3) | 123761 |
| Distinct | 90 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Minimum | 2025-01-01 00:00:00 |
|---|---|
| Maximum | 2025-03-31 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
| Distinct | 90 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Minimum | 2025-01-01 00:00:00 |
|---|---|
| Maximum | 2025-03-31 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
| Distinct | 90 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Minimum | 2025-01-01 00:00:00 |
|---|---|
| Maximum | 2025-03-31 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Payout Date
Date
| Distinct | 65 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Minimum | 2025-01-02 00:00:00 |
|---|---|
| Maximum | 2025-04-02 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Payment Gateway Type
Categorical
High correlation 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.8 MiB |
| Cybersource | |
|---|---|
| PayPal | |
| GoCardless |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 9.0007504 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PayPal |
|---|---|
| 2nd row | GoCardless |
| 3rd row | GoCardless |
| 4th row | Cybersource |
| 5th row | PayPal |
Common Values
| Value | Count | Frequency (%) |
| Cybersource | 47296 | |
| PayPal | 47110 | |
| GoCardless | 46844 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| cybersource | 47296 | |
| paypal | 47110 | |
| gocardless | 46844 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 141436 | |
| r | 141436 | |
| a | 141064 | |
| s | 140984 | |
| y | 94406 | |
| P | 94220 | |
| C | 94140 | |
| o | 94140 | |
| l | 93954 | |
| b | 47296 | 3.7% |
| Other values (4) | 188280 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1271356 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 141436 | |
| r | 141436 | |
| a | 141064 | |
| s | 140984 | |
| y | 94406 | |
| P | 94220 | |
| C | 94140 | |
| o | 94140 | |
| l | 93954 | |
| b | 47296 | 3.7% |
| Other values (4) | 188280 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1271356 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 141436 | |
| r | 141436 | |
| a | 141064 | |
| s | 140984 | |
| y | 94406 | |
| P | 94220 | |
| C | 94140 | |
| o | 94140 | |
| l | 93954 | |
| b | 47296 | 3.7% |
| Other values (4) | 188280 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1271356 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 141436 | |
| r | 141436 | |
| a | 141064 | |
| s | 140984 | |
| y | 94406 | |
| P | 94220 | |
| C | 94140 | |
| o | 94140 | |
| l | 93954 | |
| b | 47296 | 3.7% |
| Other values (4) | 188280 |
Interactions
Correlations
| Card Brand | Card Last 4 Digits | Fraud Score | Gateway Net Settled Amount | Merchant Account ID | Merchant Processor Type | Net Amount to Merchant | Payment Gateway Type | Payment Method Type | Processor Fees | Processor Response Message | Transaction Amount | Transaction Currency | Transaction Status | Transaction Type | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Card Brand | 1.000 | 0.000 | 0.000 | 0.012 | 0.006 | 1.000 | 0.013 | 1.000 | 1.000 | 0.336 | 0.000 | 0.012 | 0.006 | 0.000 | 0.000 |
| Card Last 4 Digits | 0.000 | 1.000 | -0.006 | 0.005 | 0.000 | 0.000 | 0.005 | 1.000 | 1.000 | 0.004 | 0.000 | 0.005 | 0.000 | 0.000 | 0.000 |
| Fraud Score | 0.000 | -0.006 | 1.000 | 0.001 | 0.003 | 0.000 | 0.001 | 0.001 | 0.001 | 0.002 | 0.003 | 0.001 | 0.005 | 0.008 | 0.003 |
| Gateway Net Settled Amount | 0.012 | 0.005 | 0.001 | 1.000 | 0.002 | 0.004 | 1.000 | 0.000 | 0.000 | 0.095 | 0.577 | 1.000 | 0.004 | 0.300 | 0.577 |
| Merchant Account ID | 0.006 | 0.000 | 0.003 | 0.002 | 1.000 | 0.816 | 0.005 | 1.000 | 1.000 | 0.302 | 0.000 | 0.000 | 1.000 | 0.006 | 0.000 |
| Merchant Processor Type | 1.000 | 0.000 | 0.000 | 0.004 | 0.816 | 1.000 | 0.011 | 1.000 | 1.000 | 0.589 | 0.000 | 0.000 | 0.001 | 0.004 | 0.000 |
| Net Amount to Merchant | 0.013 | 0.005 | 0.001 | 1.000 | 0.005 | 0.011 | 1.000 | 0.012 | 0.012 | 0.086 | 0.575 | 1.000 | 0.004 | 0.300 | 0.575 |
| Payment Gateway Type | 1.000 | 1.000 | 0.001 | 0.000 | 1.000 | 1.000 | 0.012 | 1.000 | 1.000 | 0.640 | 0.000 | 0.000 | 0.000 | 0.005 | 0.000 |
| Payment Method Type | 1.000 | 1.000 | 0.001 | 0.000 | 1.000 | 1.000 | 0.012 | 1.000 | 1.000 | 0.640 | 0.000 | 0.000 | 0.000 | 0.005 | 0.000 |
| Processor Fees | 0.336 | 0.004 | 0.002 | 0.095 | 0.302 | 0.589 | 0.086 | 0.640 | 0.640 | 1.000 | 0.006 | 0.098 | 0.001 | 0.010 | 0.006 |
| Processor Response Message | 0.000 | 0.000 | 0.003 | 0.577 | 0.000 | 0.000 | 0.575 | 0.000 | 0.000 | 0.006 | 1.000 | 0.577 | 0.000 | 1.000 | 1.000 |
| Transaction Amount | 0.012 | 0.005 | 0.001 | 1.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.098 | 0.577 | 1.000 | 0.004 | 0.301 | 0.577 |
| Transaction Currency | 0.006 | 0.000 | 0.005 | 0.004 | 1.000 | 0.001 | 0.004 | 0.000 | 0.000 | 0.001 | 0.000 | 0.004 | 1.000 | 0.000 | 0.000 |
| Transaction Status | 0.000 | 0.000 | 0.008 | 0.300 | 0.006 | 0.004 | 0.300 | 0.005 | 0.005 | 0.010 | 1.000 | 0.301 | 0.000 | 1.000 | 1.000 |
| Transaction Type | 0.000 | 0.000 | 0.003 | 0.577 | 0.000 | 0.000 | 0.575 | 0.000 | 0.000 | 0.006 | 1.000 | 0.577 | 0.000 | 1.000 | 1.000 |
Missing values
Sample
| Processor Transaction ID | Merchant Account ID | Merchant Processor Type | Transaction Type | Transaction Status | Transaction Amount | Transaction Currency | Processor Response Code | Processor Response Message | Payment Method Type | Card Brand | Card Last 4 Digits | Card Expiration Date | Bank Name | Bank Account Type | Payment Method Token | Merchant Order ID | Customer ID | AVS Result Code | CVV/CVC Result Code | Fraud Score | Fraud Action | Gateway Net Settled Amount | Processor Fees | Net Amount to Merchant | Settlement Batch ID | Settlement Date | Acquirer Reference Number (ARN) | Transaction Timestamp | Last Update Timestamp | Payment Gateway Date | Payout Date | Payment Gateway Type | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | PROC-TRX-96148747 | MERCH_PAYPAL_USD | PayPal | payment | settled | 2592.98 | USD | 0 | Approved | PayPal | NaN | NaN | 12/28 | NaN | NaN | TOK_850912 | PAY-0000000 | CUST-PROC-2479 | NaN | NaN | 60.6 | allow | 2573.53 | 0.00 | 2573.53 | SET-20250130-PayPal-N/A-USD | 2025-01-31 | NaN | 2025-01-30 | 2025-01-30 | 2025-01-30 | 2025-01-31 | PayPal |
| 1 | PROC-TRX-53756634 | MERCH_GOCARDLESS_USD | GoCardless | payment | settled | 4277.28 | USD | 0 | Approved | ACH | NaN | NaN | 12/28 | Bank of Example | Checking | NaN | PAY-0000001 | CUST-PROC-4051 | NaN | NaN | 0.6 | allow | 4266.59 | 0.00 | 4266.59 | SET-20250110-GoCardless-N/A-USD | 2025-01-13 | NaN | 2025-01-10 | 2025-01-10 | 2025-01-10 | 2025-01-13 | GoCardless |
| 2 | PROC-TRX-96643401 | MERCH_GOCARDLESS_USD | GoCardless | payment | settled | 2515.78 | USD | 0 | Approved | ACH | NaN | NaN | 12/28 | Bank of Example | Checking | NaN | PAY-0000002 | CUST-PROC-4566 | NaN | NaN | 2.4 | allow | 2509.49 | 0.00 | 2509.49 | SET-20250221-GoCardless-N/A-USD | 2025-02-24 | NaN | 2025-02-21 | 2025-02-21 | 2025-02-21 | 2025-02-24 | GoCardless |
| 3 | PROC-TRX-48503361 | MERCH_CYBERSOURCE_GBP | ClientLine | payment | settled | 2874.81 | GBP | 0 | Approved | Credit Card | Visa | 9887.0 | 12/28 | NaN | NaN | TOK_268155 | PAY-0000003 | CUST-PROC-4425 | Y | M | 12.6 | allow | 2846.06 | 28.75 | 2817.31 | SET-20250104-ClientLine-Visa-GBP | 2025-01-07 | ARN618188908 | 2025-01-04 | 2025-01-04 | 2025-01-04 | 2025-01-07 | Cybersource |
| 4 | PROC-TRX-87613870 | MERCH_PAYPAL_USD | PayPal | payment | settled | 350.01 | USD | 0 | Approved | PayPal | NaN | NaN | 12/28 | NaN | NaN | TOK_866077 | PAY-0000004 | CUST-PROC-1238 | NaN | NaN | 63.3 | allow | 347.38 | 0.00 | 347.38 | SET-20250316-PayPal-N/A-USD | 2025-03-19 | NaN | 2025-03-16 | 2025-03-16 | 2025-03-16 | 2025-03-19 | PayPal |
| 5 | PROC-TRX-40189275 | MERCH_CYBERSOURCE_USD | ClientLine | payment | settled | 4412.91 | USD | 0 | Approved | Credit Card | Mastercard | 9534.0 | 12/28 | NaN | NaN | TOK_244127 | PAY-0000005 | CUST-PROC-9562 | Y | M | 93.4 | allow | 4368.78 | 44.13 | 4324.65 | SET-20250210-ClientLine-Mastercard-USD | 2025-02-11 | ARN591055160 | 2025-02-10 | 2025-02-10 | 2025-02-10 | 2025-02-11 | Cybersource |
| 6 | PROC-TRX-13724055 | MERCH_GOCARDLESS_AUD | GoCardless | payment | settled | 399.15 | AUD | 0 | Approved | ACH | NaN | NaN | 12/28 | Bank of Example | Checking | NaN | PAY-0000006 | CUST-PROC-8369 | NaN | NaN | 96.5 | allow | 398.15 | 0.00 | 398.15 | SET-20250207-GoCardless-N/A-AUD | 2025-02-10 | NaN | 2025-02-07 | 2025-02-07 | 2025-02-07 | 2025-02-10 | GoCardless |
| 7 | PROC-TRX-57320369 | MERCH_GOCARDLESS_GBP | GoCardless | payment | settled | 1639.12 | GBP | 0 | Approved | ACH | NaN | NaN | 12/28 | Bank of Example | Checking | NaN | PAY-0000007 | CUST-PROC-5373 | NaN | NaN | 50.8 | allow | 1635.02 | 0.00 | 1635.02 | SET-20250220-GoCardless-N/A-GBP | 2025-02-21 | NaN | 2025-02-20 | 2025-02-20 | 2025-02-20 | 2025-02-21 | GoCardless |
| 8 | PROC-TRX-36380772 | MERCH_CYBERSOURCE_USD | Amex | payment | settled | 802.45 | USD | 0 | Approved | Credit Card | Amex | 2535.0 | 12/28 | NaN | NaN | TOK_513827 | PAY-0000008 | CUST-PROC-6283 | Y | M | 41.0 | allow | 794.43 | 12.04 | 782.39 | SET-20250225-Amex-Amex-USD | 2025-02-26 | ARN184492302 | 2025-02-25 | 2025-02-25 | 2025-02-25 | 2025-02-26 | Cybersource |
| 9 | PROC-TRX-55314596 | MERCH_CYBERSOURCE_USD | ClientLine | payment | settled | 4780.71 | USD | 0 | Approved | Credit Card | Mastercard | 6108.0 | 12/28 | NaN | NaN | TOK_505369 | PAY-0000009 | CUST-PROC-2142 | Y | M | 33.8 | allow | 4732.90 | 47.81 | 4685.09 | SET-20250223-ClientLine-Mastercard-USD | 2025-02-26 | ARN314680266 | 2025-02-23 | 2025-02-23 | 2025-02-23 | 2025-02-26 | Cybersource |
| Processor Transaction ID | Merchant Account ID | Merchant Processor Type | Transaction Type | Transaction Status | Transaction Amount | Transaction Currency | Processor Response Code | Processor Response Message | Payment Method Type | Card Brand | Card Last 4 Digits | Card Expiration Date | Bank Name | Bank Account Type | Payment Method Token | Merchant Order ID | Customer ID | AVS Result Code | CVV/CVC Result Code | Fraud Score | Fraud Action | Gateway Net Settled Amount | Processor Fees | Net Amount to Merchant | Settlement Batch ID | Settlement Date | Acquirer Reference Number (ARN) | Transaction Timestamp | Last Update Timestamp | Payment Gateway Date | Payout Date | Payment Gateway Type | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 141240 | PROC-TRX-32788723 | MERCH_GOCARDLESS_USD | GoCardless | chargeback_reversal | disputed | 689.24 | USD | C02 | Chargeback Reversed | ACH | NaN | NaN | 12/28 | Bank of Example | Checking | NaN | REV-0107910 | CUST-PROC-6672 | NaN | NaN | 69.5 | allow | 687.52 | 0.00 | 687.52 | SET-20250326-GoCardless-N/A-USD | 2025-03-27 | NaN | 2025-03-26 | 2025-03-26 | 2025-03-26 | 2025-03-27 | GoCardless |
| 141241 | PROC-TRX-72456201 | MERCH_CYBERSOURCE_USD | ClientLine | chargeback_reversal | disputed | 2318.44 | USD | C02 | Chargeback Reversed | Credit Card | Mastercard | 5928.0 | 12/28 | NaN | NaN | TOK_629291 | REV-0024103 | CUST-PROC-9714 | Y | M | 17.3 | allow | 2295.26 | 23.18 | 2272.08 | SET-20250306-ClientLine-Mastercard-USD | 2025-03-07 | ARN263111260 | 2025-03-06 | 2025-03-06 | 2025-03-06 | 2025-03-07 | Cybersource |
| 141242 | PROC-TRX-53974940 | MERCH_CYBERSOURCE_CAD | Amex | chargeback_reversal | disputed | 4353.13 | CAD | C02 | Chargeback Reversed | Credit Card | Amex | 8590.0 | 12/28 | NaN | NaN | TOK_952318 | REV-0039969 | CUST-PROC-6116 | Y | M | 33.3 | allow | 4309.60 | 65.30 | 4244.30 | SET-20250311-Amex-Amex-CAD | 2025-03-12 | ARN135414927 | 2025-03-11 | 2025-03-11 | 2025-03-11 | 2025-03-12 | Cybersource |
| 141243 | PROC-TRX-11820156 | MERCH_PAYPAL_GBP | PayPal | chargeback_reversal | disputed | 28.61 | GBP | C02 | Chargeback Reversed | PayPal | NaN | NaN | 12/28 | NaN | NaN | TOK_718010 | REV-0101060 | CUST-PROC-1705 | NaN | NaN | 43.7 | allow | 28.40 | 0.00 | 28.40 | SET-20250131-PayPal-N/A-GBP | 2025-02-03 | NaN | 2025-01-31 | 2025-01-31 | 2025-01-31 | 2025-02-03 | PayPal |
| 141244 | PROC-TRX-37925899 | MERCH_GOCARDLESS_USD | GoCardless | chargeback_reversal | disputed | 2263.30 | USD | C02 | Chargeback Reversed | ACH | NaN | NaN | 12/28 | Bank of Example | Checking | NaN | REV-0020178 | CUST-PROC-5907 | NaN | NaN | 43.4 | allow | 2257.64 | 0.00 | 2257.64 | SET-20250124-GoCardless-N/A-USD | 2025-01-27 | NaN | 2025-01-24 | 2025-01-24 | 2025-01-24 | 2025-01-27 | GoCardless |
| 141245 | PROC-TRX-26208812 | MERCH_GOCARDLESS_USD | GoCardless | chargeback_reversal | disputed | 2573.44 | USD | C02 | Chargeback Reversed | ACH | NaN | NaN | 12/28 | Bank of Example | Checking | NaN | REV-0025245 | CUST-PROC-6978 | NaN | NaN | 69.0 | allow | 2567.01 | 0.00 | 2567.01 | SET-20250312-GoCardless-N/A-USD | 2025-03-13 | NaN | 2025-03-12 | 2025-03-12 | 2025-03-12 | 2025-03-13 | GoCardless |
| 141246 | PROC-TRX-55820069 | MERCH_CYBERSOURCE_EUR | Amex | chargeback_reversal | disputed | 794.03 | EUR | C02 | Chargeback Reversed | Credit Card | Amex | 8120.0 | 12/28 | NaN | NaN | TOK_778198 | REV-0093761 | CUST-PROC-4520 | Y | M | 36.2 | allow | 786.09 | 11.91 | 774.18 | SET-20250101-Amex-Amex-EUR | 2025-01-02 | ARN131111169 | 2025-01-01 | 2025-01-01 | 2025-01-01 | 2025-01-02 | Cybersource |
| 141247 | PROC-TRX-14765444 | MERCH_PAYPAL_USD | PayPal | chargeback_reversal | disputed | 3629.53 | USD | C02 | Chargeback Reversed | PayPal | NaN | NaN | 12/28 | NaN | NaN | TOK_797724 | REV-0103102 | CUST-PROC-9579 | NaN | NaN | 85.2 | allow | 3602.31 | 0.00 | 3602.31 | SET-20250213-PayPal-N/A-USD | 2025-02-14 | NaN | 2025-02-13 | 2025-02-13 | 2025-02-13 | 2025-02-14 | PayPal |
| 141248 | PROC-TRX-18452065 | MERCH_CYBERSOURCE_USD | ClientLine | chargeback_reversal | disputed | 2700.28 | USD | C02 | Chargeback Reversed | Credit Card | Mastercard | 8696.0 | 12/28 | NaN | NaN | TOK_890568 | REV-0039089 | CUST-PROC-2021 | Y | M | 5.8 | allow | 2673.28 | 27.00 | 2646.28 | SET-20250210-ClientLine-Mastercard-USD | 2025-02-11 | ARN894657558 | 2025-02-10 | 2025-02-10 | 2025-02-10 | 2025-02-11 | Cybersource |
| 141249 | PROC-TRX-40563623 | MERCH_GOCARDLESS_CAD | GoCardless | chargeback_reversal | disputed | 2500.12 | CAD | C02 | Chargeback Reversed | ACH | NaN | NaN | 12/28 | Bank of Example | Checking | NaN | REV-0022422 | CUST-PROC-1156 | NaN | NaN | 76.2 | allow | 2493.87 | 0.00 | 2493.87 | SET-20250105-GoCardless-N/A-CAD | 2025-01-08 | NaN | 2025-01-05 | 2025-01-05 | 2025-01-05 | 2025-01-08 | GoCardless |